Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a address column with comma separated values like The Business Centre,61 Wellfield Road,Roath,Cardiff
Can i separate this values into one by one with comma like,
The Business Centre,
61 Wellfield Road,
Roath,
Cardiff
If possible Can anyone explain how can i do this?
Regards,
Mani
Yes, you can
Concat(fieldname,',',chr(10)) as newfield
I think all you need is this
LOAD SubField(FieldName, ',') as NewField
Read here about SubField function:
Hi,
if you really want to keep the trailing comma, then one solution could be:
LOAD *,
Replace(SubField(Replace(Address,',','@comma@,'),','),'@comma@',',') as AddressSubstring
INLINE [
Address
"The Business Centre,61 Wellfield Road,Roath,Cardiff"
"QLIKTECH UK LTD, 1020 Eskdale Road, Winnersh, Wokingham, Berkshire"
];
hope this helps
regards
Marco
Use replace() and replace comma "," value to get your result .
Thanks,
Hi Marco Wedel thanks for reply...
This is my expected result but it is not working in text box and this script gets the values in ascending order like,
61 Wellfield Road,
Cardiff
The Business Centre,
Roath,
i want the actual result is showing in text box,,,,
Thanks,
Mani
Replace(Address,',',','& Chr(10))
Regards
Marco