Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
I have a field with values like below
1234-abc
13422-monday
136647536-tuesday
I need to display only the part before '-'
eg) 1234 , 13422, 136647536.
Kindly help me what function I can use to get above result.
Thanks in advance...
You can use SubField function here:
SubField(FieldName, '-', 1) as FieldName
You can use SubField function here:
SubField(FieldName, '-', 1) as FieldName
=SubField(YourOriginalField, '-', 1)
= left(fieldname, (len(fieldname) - index(fieldname, '-'))
See this script:
Table:
LOAD *,
SubField(FieldName, '-', 1) as Part1,
SubField(FieldName, '-', 2) as Part2;
LOAD * Inline [
FieldName
1234-abc
13422-monday
136647536-tuesday
];
It's output:
Hi Chintan,
try this:
left(Value,index(Value,'-')-1) AS Partleft
best regards
Christoph
Hello Sunny
Can I use this in front end report ? I want something which can be user in report and not script.
Regards
Chintan Gala
Yes you can use in the front end also .
subfield(filed_name,'-',1) use this expression in the list box and charts
Thanks!
Good discussion thread here. Please be sure to mark helpful and correct answers.
Sara