CODEWITHSUNDEEP
apache-spark-sqlsubstringpalantir-foundrytext-formattingfoundry-contour
Turpan
Turpan

Reputation: 537

formating text to a new field in foundry contour

I need to transform text from one field to a new one. Currently the TEXTVALUE is "202411219999". The NEWVALUE to obtain must be like this: "2024-11-21"

I managed to use substring("TEXTVALUE", 1, 4) in the expresion function, getting first 4 characters from TEXTVALUE.

Do you know how can I use 3 substrings maybe in one expersion to obtain final "2024-11-21" ? I think palantir is using spark SQL for this.

Thank you

Upvotes: 0

Views: 46

Answers (1)

Ahmed Sunny
Ahmed Sunny

Reputation: 2243

you can use concat to concatenate multiple substings,

concat(substring("TEXTVALUE", 1, 4), '-', 
       substring("TEXTVALUE", 5, 2), '-', 
       substring("TEXTVALUE", 7, 2))

Upvotes: 0

Related Questions