Skip to main content
Question

Sort and Segregate text message

  • November 11, 2019
  • 0 replies
  • 30 views
Hi All,

Can some help me to split a column into two columns 

N|1|04-29-2013 ; N|2|06-11-2015 ; N|3|07-27-2017 ; N|5|04-05-2020 ; Y|1|04-29-2013 ; Y|2|04-29-2014 ; Y|3|04-29-2015 ; Y|4|02-23-2019

I want to convert to 
N|1|04-29-2013 ; N|2|06-11-2015 ; N|3|07-27-2017 ; N|5|04-05-2020 ;  ---> to column N
 Y|1|04-29-2013 ; Y|2|04-29-2014 ; Y|3|04-29-2015 ; Y|4|02-23-2019 ----> to column Y

Thanks

------------------------------
Pushpakumar Gnanadurai
------------------------------
This topic has been closed for replies.

  • EricMohlman
  • Quickbase Staff
  • November 11, 2019
Pushpakumar,

If you create two formula - text type fields, you can enter these formulas into each:
Trim(Left([TextFieldName],"Y"))
Trim(NotLeft([TextFieldName],"Y"))

Those will split your current text field into the two sets of information that you want.

------------------------------
Eric Mohlman
------------------------------
    Terms & ConditionsAccessibility statement