splitting single row into multiple values

[Anonymous]

Hi

I need to split a single row into multiple rows based on the Values present in the Name field. If there is enter in a row i.e . chr(13) the ticket needs to be shown as a separate row

Attaching a screenshot of the current vs desired table. Is it possibel to use subfield with chr(13)?

[sunny_talwar · Accepted solution]

May be it is Chr(10)

SubField(Name, Chr(10))

or

SubField(Name, Chr(13))

or

SubField(Name, Chr(13)&Chr(10))

UPDATE: You are trying to do this in the script right?

[Anonymous]

yes,,chr(10) worked