Substring

[#1]

Hi,

I have a question, i have a field that has the value like 'Hilary/12yo' i want to separate this data into two fields, let's say Name and Age. i want to cut the value when meet the '/' symbol and put 'Hilary' into Name field and put '12yo' into Age field. Does anybody know the function to separate the value ?

Really need your help, your comments and view are really appreciated.

Thanks

[sunny_talwar · Accepted solution]

If you are trying to do it in script, you can try this:

LOAD Fields,

          SubField(YourField, '/', 1) as Name,

          SubField(YourField, '/', 2) as Age,

From abc

HTH

Best,

Sunny

[sunny_talwar]

Attaching a sample for reference.

[#4]

Hi Sunindia,

Thanks for your help. It works and solve my problem.