Skip to main content
Web Applications

Return to Question

Bumped by Community user
deleted 122 characters in body; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

Formatting/Ingestingingesting text in Google Docs and Google SpreadsheetsSheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant Google docDocs that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 11 or 00. These lines where takewere taken from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 11 or 00.

The excelExcel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

Everything with a `1` should be right aligned on this document.
Everything with a `0` should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the docdocument). I suspect trying to select the lines in the docdocument may be more difficult, since some text blockblocks span multiple paragraphs but only have one numeric indicator.

Formatting/Ingesting text in Google Docs and Google Spreadsheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant Google doc that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines where take from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the doc). I suspect trying to select the lines in the doc may be more difficult, since some text block span multiple paragraphs but only have one numeric indicator.

Formatting/ingesting text in Google Docs and Google Sheets

I have a giant Google Docs that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines were taken from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The Excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a `1` should be right aligned on this document.
Everything with a `0` should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the document). I suspect trying to select the lines in the document may be more difficult, since some text blocks span multiple paragraphs but only have one numeric indicator.

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
deleted 2 characters in body; edited title
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

Formatting/Ingesting text in google docsGoogle Docs and google spreadsheetsGoogle Spreadsheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant googleGoogle doc that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines where take from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the doc). I suspect trying to select the lines in the doc may be more difficult, since some text block span multiple paragraphs but only have one numeric indicator.

Formatting/Ingesting text in google docs and google spreadsheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant google doc that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines where take from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the doc). I suspect trying to select the lines in the doc may be more difficult, since some text block span multiple paragraphs but only have one numeric indicator.

Formatting/Ingesting text in Google Docs and Google Spreadsheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant Google doc that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines where take from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the doc). I suspect trying to select the lines in the doc may be more difficult, since some text block span multiple paragraphs but only have one numeric indicator.

Source Link
DocsQuestion
DocsQuestion
  • 31
  • 1

Formatting/Ingesting text in google docs and google spreadsheets

I have a bit of a conundrum. I'm not sure the best forum to ask this question, so feel free to point me in the right direction if it's not here.

I have a giant google doc that looks like this:

...
this is a line with some text, 1
this is a line with some more text, 1
here is another line with some text, 0
here is another line with some text, 1
here is yet another line with text, 0
and finally here is a line with text, 1
...

The lines with text can be anywhere from a few words to a few paragraphs. However, they always end in either a 1 or 0. These lines where take from a spreadsheet, and I can access them as text block in a cell with an adjacent column containing 1 or 0.

The excel would look something like:

-----------------
block of text | 0
block of text | 1
block of text | 0
block of text | 0
block of text | 1
------------------

The problem I face:

Everything with a 1 should be right aligned on this document.

Everything with a 0 should be left aligned on this document.

I'm hoping there is a way to do this (either my writing a function/using a tool on the spreadsheet or selecting relevant text in the doc). I suspect trying to select the lines in the doc may be more difficult, since some text block span multiple paragraphs but only have one numeric indicator.