Edit Text field in Data Load Editor

[David_K]

Good Morning fellow Qlik Sense Users,

I have a data set that has the customer name and city as a single field, and I'd like to be able to separate this into two fields, Customer  /  City

France_Cust_001, Paris 

Germany_Cust_947, Berlin

I need to be able to separate the field based on the location of the comma.  In Excel, I can use the formulas below to create  new columns for the Customer Name / City

Customer:   LEFT(A1,FIND(",",A1)-1)

City:   RIGHT(A1,LEN(A1)-FIND(",",A1))

Can anyone please help in advising a way I can execute a similar function in Qlik.

Many thanks in advance for your help,

David

[rajjul · Accepted solution]

you can use subfield

SubField(A,',' 1)

SubField(A,',' 2)

The first one gives you field name A with a comma separating with the left side (Country).The Second one gives you field name A with a comma separating with the right side (city)

[David_K]

Thank you Rajjul, works perfectly, and helps build my knowledge base of the application