chinese sites are .CN not .comThat's their Chinese site. Pretty good Engrish, no?
***Monday GMT***
- Thread starter Pesqueeb
- Start date
It's a block on numbers (1 2 4 5 6) with erratic spacing and no delimiters.
maybe just yell at whoever emailed you bad data in the first place.
Not his problem. It's the program that exports the data in shit format.
#value response. Not sure if you're fucking with me...
If you order from that site, they are going to come over on a slow boat from China.
The NA site is here: https://us.lightbicycle.com/
Do the two step. Do the fixed width slice, then copy the numbers that aren't numbers and paste them into notepad, then copy and paste that back into Excel once the embedded formatting has been scrubbed.
Or send it back to the asshat who sent it to you and tell them to enter that isht in Excel.
... do you have power query?
you put the cell you want the value of in parenthesis. it works for me, then again i'm using office 2016.
https://www.lightbicycle.com/26er-Hand-built-Endro-Downhill-carbon-fiber-wheelset-38mm-wide-tubeless-compatible.html
That's their Chinese site. Pretty good Engrish, no?
What SS said...that's the Chinese site. This is their US site:
https://us.lightbicycle.com/
I'm doing this as a back door until I can query. It's my manager, so I can only do so much re: sending it back to get batter data.
Power Query is an Excel plug-in that will allow you to query and transform data inside of Excel. If you have it installed in Excel, you could use it to transform the text data.
notepad++ is quite monocle though @stoney
You are using words I don't know, so I doubt it then.
Neither are working. I guess we're going to have to wait until I get program access.
awk!Put file on Linux box. Use built-in utilities to pull out the offending formatting.
I was about to post that I also use Textpad and notepad++ depending upon what I'm doing. Block select mode and regular expressions have been used lots in my work.
Or as SS said, go command line in *nix. Cygwin in Windows was being used by me this morning.
That's one way.
Print email to PDF. Convert PDF to text. Paste text.
How about just print out email on paper, then enter values manually from paper to cells?
Seems like too much work.How about just print out email on paper, then enter values manually from paper to cells?
Perhaps just try it now.
Dishes done, final load of laundry in, floor swept and I'm ready for a beer! Monkeyfest was a success!
Overnight flights are a bitch—Mariko really did not want to wake up and sit straight for landing. Perhaps no Hawaii again for a few years. Didn't help that the wife put the keys from the valet in the front cup holder and then the kids scrambling about the car closed the lid on said cup holder. We couldn't find them for a solid 15 minutes or so, replete with sleep addled brains.
Buzzkill.
that's more a function of your adobe installAnd apparently when they gave me 2010, I lost the ability to print to PDF.
my name is Jonkranked
i think i must be tanked
cause English looks Chinese to me
I deserve to be spanked
i think i must be tanked
cause English looks Chinese to me
I deserve to be spanked
Can you "Save as" pdf?And apparently when they gave me 2010, I lost the ability to print to PDF.
This GMT brought to you by office life.
Short lunch ride was had. No enduroing, but I did ride with a bottle instead of a pack.
Short lunch ride was had. No enduroing, but I did ride with a bottle instead of a pack.
Is that image what happens before bro dozering?
"Spot me cause I'ma hit this mud hole with some speed and don't wanna risk body damage!"