Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Sergio,
Try pasting this into a simple formula text field. It converts the string to all numbers and then inserts the delimiters back into the string.
Change [Raw input] to your field name.
var text MyString = [Raw input];
var text PartOne = Part($MyString,1, "./-");
var text PartTwo = Part($MyString,2, "./-");
var text PartThree = Part($MyString,3, "./-");
var text PartFour = Part($MyString,4, "./-");
var text PartFive = Part($MyString,5, "./-");
var text AllNumbers = List("",$PartOne,$PartTwo,$PartThree,$PartFour,$PartFive);
Left($AllNumbers,3)
& "."
& Mid($AllNumbers,4,3)
& "."
& Mid($AllNumbers,7,3)
& "/"
& Mid($AllNumbers,10,4)
& "-"
& Mid($AllNumbers,14,2)
Try pasting this into a simple formula text field. It converts the string to all numbers and then inserts the delimiters back into the string.
Change [Raw input] to your field name.
var text MyString = [Raw input];
var text PartOne = Part($MyString,1, "./-");
var text PartTwo = Part($MyString,2, "./-");
var text PartThree = Part($MyString,3, "./-");
var text PartFour = Part($MyString,4, "./-");
var text PartFive = Part($MyString,5, "./-");
var text AllNumbers = List("",$PartOne,$PartTwo,$PartThree,$PartFour,$PartFive);
Left($AllNumbers,3)
& "."
& Mid($AllNumbers,4,3)
& "."
& Mid($AllNumbers,7,3)
& "/"
& Mid($AllNumbers,10,4)
& "-"
& Mid($AllNumbers,14,2)
SergioSergio
8 years agoQrew Cadet
Enjoy the snow my friend!
I have been losing all my hairs trying to get this done. But I know once i learned the first one, I will be able to implement the other ones.
I will use yours for now, but I am challenged to get this accomplished now.
Lets see if i understood:
1- I followed all the instructions and I created the user iol and /iol
2- I created the page module.js and added the long script where shows what page I am working on.
3- I created a normal text field named [taxid].
4- I need to create a field name [iol] & "module.js" & [/iol] ?
5- Is number 4 correct? or i just need to paste that "[iol] & "module.js" & [/iol]" into a another field text formula type?
Anyways, I wont give up on this one yet, but for now I will use Marks proposal so I can at least have something working today.
Thanks for both of you!
I have been losing all my hairs trying to get this done. But I know once i learned the first one, I will be able to implement the other ones.
I will use yours for now, but I am challenged to get this accomplished now.
Lets see if i understood:
1- I followed all the instructions and I created the user iol and /iol
2- I created the page module.js and added the long script where shows what page I am working on.
3- I created a normal text field named [taxid].
4- I need to create a field name [iol] & "module.js" & [/iol] ?
5- Is number 4 correct? or i just need to paste that "[iol] & "module.js" & [/iol]" into a another field text formula type?
Anyways, I wont give up on this one yet, but for now I will use Marks proposal so I can at least have something working today.
Thanks for both of you!