Skip to main content

Invert a string like in excel

  • October 29, 2020
  • 5 replies
  • 67 views
N
Forum|alt.badge.img+2

Hello everyone!

I need your ideas :slightly_smiling_face:

I am trying to invert a string (of numbers). I had this nice easy formula in excel, but I am not sure how to transform it to Airtable as it contain an array.

exemple:
A1: 123456
A2: =TEXTJOIN("",1,MID(I49,{10,9,8,7,6,5,4,3,2,1},1))
result in A2: 654321

Is it possible to convert or do I need a new method? Those functions seems to be available in Airtable, but nothing worked from all I tried. As I could not find similar case in the forum I am asking it here today so others can also get an a solution!

Thank you very much for your kind clairvoyance :grinning_face_with_big_eyes:

5 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • October 29, 2020

While Airtabe may have formula functions with similar names as Excel’s functions, they do not necessarily do the same thing.

For example, Airtable formulas cannot split a text string into an array/list, and the array formula functions only work on very specific field types.

I recommend looking into using scripting to achieve this. Scripting use JavaScript, which has several string handling functions.

N
N
Forum|alt.badge.img+2
  • Nicolas_Lapierr
  • Author
  • Known Participant
  • October 29, 2020

While Airtabe may have formula functions with similar names as Excel’s functions, they do not necessarily do the same thing.

For example, Airtable formulas cannot split a text string into an array/list, and the array formula functions only work on very specific field types.

I recommend looking into using scripting to achieve this. Scripting use JavaScript, which has several string handling functions.


Yes scripting, that would be the next step. I wanted to be sure that I was not missing an easy way to do it :slightly_smiling_face: Thank you!

kuovonne
C
B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • October 30, 2020

Yes scripting, that would be the next step. I wanted to be sure that I was not missing an easy way to do it :slightly_smiling_face: Thank you!


And if Airtable was interested in creating a self-sustaining formula environment, there would already be a script block available to everyone named Reverse.js that could be mapped to the formula Reverse().

[sigh]

N
N
Forum|alt.badge.img+2
  • Nicolas_Lapierr
  • Author
  • Known Participant
  • October 31, 2020

And if Airtable was interested in creating a self-sustaining formula environment, there would already be a script block available to everyone named Reverse.js that could be mapped to the formula Reverse().

[sigh]


Yes!! That would open so many doors for newbies like us trying to find easier/faster way than scripting! You probably suggested it already, did you?

By the way, a big THANK YOU to both of you @Bill.French & @kuovonne for all your answers to the community, I saw your clever comments and solutions in almost every post that helped me build my modest AT temple :grinning: You are making this dream going one step further!!

B
Forum|alt.badge.img+19
  • Bill_French
  • Inspiring
  • November 1, 2020

Yes!! That would open so many doors for newbies like us trying to find easier/faster way than scripting! You probably suggested it already, did you?

By the way, a big THANK YOU to both of you @Bill.French & @kuovonne for all your answers to the community, I saw your clever comments and solutions in almost every post that helped me build my modest AT temple :grinning: You are making this dream going one step further!!


Many times for more than two years.

Sean_Murphy1
Terms & ConditionsAccessibility statement