How to read 1 single string A|B|C|D from Launch and split into 4 entries in evar

[Luca_Lattarini]

Hello everyone,

How can I split this single string A|B|C|D from Launch into 4 differents entries?

Thanks

[yuhuisg · Accepted solution]

The simplest is with custom code:

var str = "A|B|C|D";
var values = str.split("|");
// values = ["A", "B", "C", "D"]

[Luca_Lattarini]

Hi yuhui, AA receives this string "A|B|C|D" via API. I would like to store in evar X (AA) A, B, C D as single entry not as string

[yuhuisg]

Then you want to use list variables https://experienceleague.adobe.com/docs/analytics/admin/admin-tools/conversion-variables/list-var-ad...

[Luca_Lattarini]

@yuhuisg: It is useful approach but now we have evar X 1:ABC|2:DEF|3:KLN from Launch and I need to save into evar (report suite), ABC OR EDF OR KLN.

[yuhuisg]

@Luca_Lattarini the solution is still the same: you need to use list variables

[yuhuisg]

--

[Luca_Lattarini]

@yuhuisg, It works well, If I use List Variable but I have an import data from API 1.4 where I dont use List Variable. Can I use List Variable from API?

[yuhuisg]

@Luca_LattariniI'm not familiar with using the API, unfortunately. But I assume that list variables should be supported.

[Luca_Lattarini]

@yuhuisg, I tried to use list2 with API 1.4 but I got an error. It is not supported. I m trying to read the string like this "1|2" by using this regex in Classification Builder((?:[^\\|]+|\\\|?)+). Any idea how to match 1 and 2? I tried ((?:[^\\|]+|\\\|?)+)[1] but it doesnt work.

[yuhuisg]

@Luca_Lattarini I think you should be using "listvar2" with the API. See https://github.com/AdobeDocs/analytics-1.4-apis/blob/master/docs/reporting-api/elements.md

[yuhuisg]

@Luca_Lattarini also, I don't think Classification will work in your use case. Classification means that for your variable, you have defined 2 classifications for it (e.g. like 2 sub-variables), and you want to use "1" in the first classification, and "2" in the second classification. But you're splitting the "1|2" string "horizontally", when based on your original post, you want to split the string "vertically".