Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

String value separated by spaces 4 years 6 months ago #14724

  • Nigel
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
I have string value that is separated by UNDERSCORES. Need help in removing the spaces in between.

Example:
CX234_MNL_BKK_2100_0100
PR110_LAX_SIN_0100_1700

Please Log in or Create an account to join the conversation.

String value separated by spaces 4 years 6 months ago #14725

Hi Nigel,

In transformation, we can use the SPLIT function in order to facilitate this.

Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 270 guests and no members online