var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Reformat in a query
I would like to re-format a text string form this format;
to this format;
It requires droping the first number, then inserting the slashes and dashes and removing the secound last number.
Thank you in advance.
Last edited by bigd2; 11-05-09 at
Look at the Mid() function and concatenation:
NewField: Mid(...) & "/" & Mid(...) & ...
Hopefully I understood correctly, in that you want the first character stripped and do not want to use the second-to-last character. If so, you can use the following in the query:
So in your example string, the characters used are
1 00012503222W40 0
Thanks Ax238 that worked perfectly. Your a friggin rockstar.
Could you show me how to format them back as I sometimes need to go either way depending on my data source? That would mean striping the slashes and dashes, and inserting a "1" at the begining and a "0" at the secound last position.
Good deal! To get the string back, just use the following:
Work perfect. Thanks again Ax238 - you rock dude!
Awesome, glad I could help!