Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have cell values in chart column as below
Sertyuid, City Tower,Piccadilly Plaza,Bayymore, B1 UY8
Capital Jones Northy,Carlton House,Mary Street,Salford,I90 UI0
I need to split data as I have to show only Data as
Sertyuid
Capital Jones Northy
I used Subfield but it is not showing correct. can anyone please suggest me how to set this.
Thanks.
If your field name is [FieldName]:
=left( [FieldName], Index( [FieldName], ',') -1 )
Can you upload sample qvw?
Load Subfield(Txt,',',1) Inline [
Txt
Sertyuid, City Tower,Piccadilly Plaza,Bayymore, B1 UY8
Capital Jones Northy,Carlton House,Mary Street,Salford,I90 UI0 ]
Hi,
can you explain
What is your Subfield() expression?
What you are getting?
Regards
If your field name is [FieldName]:
=left( [FieldName], Index( [FieldName], ',') -1 )
HI,
Try this subfield(Name,',',1) as Name
Regards
Sathish
Thanks. Its working.